<?php

require_once 'config.php';
require_once 'function.php';
require_once 'class/Mysql.class.php';

$db = new Mysql();

$arr_en = array(
    'pro/video-converter-ultimate.html',
    'pro/dvd-converter.html',
    'video-dvd-software/video-converter.html',
    'video-editor/',
    'pro/dvd-slideshow-builder-deluxe.html',
    'pro/dvd-slideshow-builder-standard.html',
    'pro/photo-collage-studio.html',
    'pro/flash-gallery-factory-deluxe.html',
    'pdf-converter/',
    'pdf-converter/pdf-to-word-converter.html',
    'pdf-converter/pdf-to-powerpoint-converter.html',
    'pro/ppt2flash-pro.html',
    'data-recovery/photo-recovery.html',
    'data-recovery/',
    'imate/',
    'mac-video-converter-ultimate/',
    'pro/mac-video-converter-pro.html',
    'pro/mac-video-converter.html',
    'video-editor/mac/',
    'pro/mac-dvd-ripper.html',
    'pro/mac-dvd-creator.html',
    'photo-software/photo-slideshow-mac.html',
    'pro/mac-icollage.html',
    'pdf-converter/mac/',
    'mac-pdf-editor/mac-pdf-editor-pro.html',
    'mac-pdf-editor/'
);

$arr_de = array(
    'produkte-detail/videoconverter-ultimate.html',
    'produkte-detail/videoconverter-pro.html',
    'produkte-detail/videoconverter-hd.html',
    'produkte-detail/video-editor.html',
    'produkte-detail/dvd-slideshowbuilder-hd-video-deluxe.html',
    'produkte-detail/dvd-slideshowbuilder-hd-foto.html',
    'produkte-detail/photo-collage-studio.html',
    'produkte-detail/flash-gallery-factory-deluxe.html',
    'produkte-detail/pdf-converter-pro.html',
    'produkte-detail/pdf-word-converter.html',
    'produkte-detail/pdf-powerpoint-converter.html',
    'produkte-detail/ppt-flash-professionell.html',
    'produkte-detail/photo-recovery.html',
    'produkte-detail/data-recovery.html',
    'produkte-detail/imate.html',
    'produkte-detail/videoconverter-ultimate-mac.html',
    'produkte-detail/videoconverter-pro_mac.html',
    'produkte-detail/videoconverter_mac.html',
    'produkte-detail/vivideo-mac.html',
    'produkte-detail/dvdconverter-mac.html',
    'produkte-detail/dvd-creator-mac.html',
    'produkte-detail/fantashow-mac.html',
    'produkte-detail/icollage_mac.html',
    'produkte-detail/pdf-converter-mac.html',
    'produkte-detail/pdf-editor-pro-mac.html',
    'produkte-detail/pdf-editor-mac.html'
);



foreach( $arr_de as $k=>$r ){
	$sql = "update topic_article set ar_content = replace(ar_content,'{$arr_en[$k]}','{$r}')";
	$db->query( $sql );
}
echo 999;

?>
